VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

Nautical/Flight Functions

Functions perform various calculations useful for planning trips. MPH2Kt: ...

Max + Min + Min_No0s

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

DialChart.zip

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...